I am aware that the order of execution of a query in SQL Server is (excluding TOP, etc):
FROM, JOIN WHERE GROUP BY HAVING SELECT ORDER BY
However, I cannot understand how in the query plan the sort (which corresponds to the order by) is done before the select (given that they are read from right to left) if the order of execution is per above => SELECT before ORDER BY.
An simple example is as follows:
I excluded a JOIN on purpose as to avoid the case of having that sort corresponding to the JOIN.