通过order by by和row_number通过mariadb中的用户变量进行排序

I've read that any order by Operation is done at the end of the query and therefore sorting cannot be forced in a result before. I've read that any order by Operation is done a