Prasenna, this is more of a consulting ask. I would advice you to reach out to
Microsoft Azure Sales. They might even be able to put you in touch with Azure Fast Track, which is a team that specializes in moving customers into Azure.
With that being said, for application 1, I would suggest reviewing
this documentation. It uses Azure SQL instead of MySQL but there is the opition to run
MySQL with your web app.
For application 2, your standard web app should be able to complete this. If the application servers are outside of Azure, you can use a VNet for connectivity. For connecting to your SQL server, you can easily add the connection string following
these steps.
The intranet app is going to require a bit more configuration. You can use an Internally Load Balanced (ILB) App Service Environment (ASE) to lock your app down to your intranet. More information on that
here. An ILB ASE does have a cost increase associated with it. You might be able to use a multi-tenant web app but
apply IP restrictions to the site. Do note though that your site will still be using a public URL if you go this route.
The above suggestions look at using Azure Web Apps. There are other ways to accomplish your ask but I hope this helps to provide a high level overview.
