Sync requirement and requirement issues state

What does this MR do and why?

This is part of state IIB of migrating requirements to work items(issues of type requirement).

Syncs state between issues(of type requirement) and requirements from both ends. Also makes sure no desync happens and if it happens logs an error.

• On UpdateRequirementService it uses a pseudo transaction to avoid desync already implemented on !64929 (merged)
• Issues::UpdateService and Issues::CloseService it uses a regular ActiveRecord transaction to avoid desync

related to #337190 (closed)

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.

ee/spec/services/requirements_management/update_requirement_service_spec.rb

@@ -60,10 +60,10 @@
               description: requirement.requirement_issue.description)
 
             # Both state enums have the same integers
-            # but on Requirement closed means archived.
+            # but on Requirement 'closed' means 'archived'.
             # requirement: enum state: { opened: 1, archived: 2 }
             # requirement issue: STATE_ID_MAP = { opened: 1, closed: 2, ...
-            expect(requirement.state.to_i). to eq(requirement.requirement_issue.state.to_i)
+            expect(requirement.read_attribute_before_type_cast(:state)). to eq(requirement.requirement_issue.state_id)
           end
         end