How to connect a sql database hosted in Azure VM from from on-premise server. Please advice

As mentioned there is no difference with any other SQL Server hosted on-prem. You have to check if TCP Port 1433 is open.

You can use Powershell and DBATools and try below from your client computer

Test-DbaConnection -SqlInstance <SQL Server Name>

Regards
Javier