It is correct that TCP port 1433 needs to be opened. However, you cannot rely on the current IP address of the Azure SQL Server. The IP address of your logical server is not static and is subject to change at any time. All connections should be made using the fully qualified DNS name (FQDN) rather than the IP address. Please refer to this documentation.
On Azure SQL Database logical server (or at the database level) add the IP of the computer to the whitelist of Azure SQL firewall.
You may also consider creating a private link as explained here.