Scaling operation is a manual one. The service doesn't support auto-scaling.
Please read the below url there is alternate way to setup auto-scaling.
How-to auto-scale Azure SQL Databases
https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-auto-scale-azure-sql-databases/ba-p/2235441
If the Answer is helpful, please click Accept Answer
and up-vote, this can be beneficial to other community members.