Move Issue.order_created_at_desc scope from EE to CE
Summary
Contributes to #42640 (closed)
Move Issue.order_created_at_desc from EE domain to CE.
Improvements
Moving Prometheus alerts from EE to CE requires a lot of code changes. All the required changes can be split and moved in several steps (as described here).