In Android, some devices are allowing to view contacts stored in SIM. But in Google standard version of Android, it is not encouraged and I couldn’t locate an option to see the SIM contacts.
That is the same case with Windows Phone to the best of my knowledge. I haven’t come across a Windows Phone which shows contacts in SIM as well. So, if you are moving to Windows Phone from Android then you have 2 options.
You can try using the Windows Phone app ‘Transfer my Data’.
Else if your new Windows Phone is unlocked / no restriction of using existing SIM then insert SIM and do Import contacts from SIM.
If there is a restriction of SIM, then you can export the contacts from SIM to a Google account, then upload the contacts in CSV and import the contacts from CSV to Microsoft account. Following link explains the steps.
If you have contacts in VCF file then please use Windows Phone Contacts+Message backup app. Install the app, take contacts backup, replace the backup stored in phone with your vcf file (keep the file name same as backup) and restore the contacts backup.