Remove operations_feature_flag_scopes table

• Please check this box if this contribution uses AI-generated content (including content generated by GitLab Duo features) as outlined in the GitLab DCO & CLA

What does this MR do and why?

Ref: #457515

This PR removes the foreign key from operations_feature_flag_scopes for the operations_feature_flags table and then drops the operations_feature_flag_scopes table which is no longer used and has no data in it.