Create the `index_next_over_limit_check_at_asc_order` synchronously

Summary

This issue is to add a migration to create the index_next_over_limit_check_at_asc_order database index(es) synchronously after it has been created/destroyed on GitLab.com.

The asynchronous index was introduced in !111819 (merged)

Notes

Relevant Handbook Page https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#add-a-migration-to-create-the-index-synchronously