Add reverse lock order option to FK removal

What does this MR do and why?

This MR adds the reverse_lock_order option to the remove_foreign_key_if_exists helper to avoid deadlock errors for high-traffic tables.

Note: The helper is tested indirectly several times by other migration tests.

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 #350271 (closed)