Can I Physically connect the Android phone to the Apple phone by the cable provided for transfer?

No, the article you came from shows that phone to phone Wi-Fi is used

here it is again https://support.apple.com/en-us/HT201196

If your wifi is broken you can use cable to transfer your documents and media to your computer folders, then similarly computer to iPhone using iTunes. You will not be able to transfer social media etc that way.