How can I log in to MacBook without internet access?

Yes, you cannot recover a Mac password. The only option is to find a way to connect to the internet. Since you have a MacBook, why not just take it to another location and then connect to the internet via an Ethernet cable to request a new password? Then use the link below. Finally, write down the new information and save it in a secure location for next time.

Change or reset the password of a macOS user account - Apple Support

It would really help if you could connect the MacBook to the Internet. Is there a reason you can't do that?

If its Wi-Fi is not working Connect your Mac to the internet - Apple Support describes methods other than Wi-Fi.