Duplicate indices on MySQL

### Apache Airflow version 3.0.3 ### If "Other Airflow 2 version" selected, which one? _No response_ ### What happened? We are checking the indices that Airflow creates on different tables to find any performance issues and we noticed on `MySQL`, there are duplicate indices created on `dag_run` table: - KEY `idx_dag_run_running_dags` (`state`,`dag_id`) - KEY `idx_dag_run_queued_dags` (`state`,`dag_id`) Even though index/key names are different, since the columns and their order are same, it is essentially the duplicate. And this will effect any `INSERT` operations and potentially `SELECT` statements too, since `MySQL` will be confused about which index among the duplicates should be used. ### What you think should happen instead? _No response_ ### How to reproduce N/A ### Operating System MySQL ### Versions of Apache Airflow Providers _No response_ ### Deployment Other Docker-based deployment ### Deployment details MySQL v8.0 ### Anything else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)