Unfortunately no. You need to back up your iPhone 6S on iTunes via you're computer. Once the 6S is backed up? Plug in you're iPhone XR and set it up under " Restore". This will restore all you're back up ( images, Texts, Videos and files including apps ans such) on you're XR.
The sim card only holds you're number.
It can also depend on the version of iOS the 6s is running as well. If it's current, copying the data to the new phone may be possible just by having the phones beside each other. That's how I transferred my data to my current iPhone.
Details here: https://support.apple.com/en-us/HT210216
If you find a post useful, please give the author a "Like" or mark as an accepted solution if it solves your trouble. 🙂