Follow-up from "Cleanup attention request reviewer state"

We need to remove the temporary index tmp_index_merge_request_reviewers_on_attention_requested_state which was introduced in !97010 (merged)