While working on https://gitlab.com/gitlab-org/gitlab/-/merge_requests/43295 I noticed that although we receive a specific order of results from elasticsearch we had a different one for our active record relation. Most of the time it was `ORDER BY id`. It happens when we [build](https://gitlab.com/gitlab-org/gitlab/blob/master/ee/lib/gitlab/elastic/search_results.rb#L173) AR relation from the elasticsearch response. This issue is created to track this problem. Most likely it will be fixed in https://gitlab.com/gitlab-org/gitlab/-/merge_requests/43295