Unecessary order by Many2One order name
#10818 (closed) added order by origin to optimize the cache alignment but the problem is that for Many2One
origin, it uses the default order which is the record name or the order name. So this requires a join on the source model (and even worst on translation table if the field is translatable).
But indeed the order is just for grouping records so ordering by id is enough and avoid join on the source table.