Async remove 'merge_request_mentions_temp_index' index

What does this MR do and why?

As mentioned in Remove unused indexes on `merge_requests` table (#402497 - closed), this index is no longer used and can be removed

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.

Related to #402497 (closed)