Is it true that the logical order of query execution may not coincide with the scheduler?

Question

SQL

The logical order of processing a SELECT statement is:
FROM
ON
JOIN
where
GROUP BY
WITH CUBE or WITH ROLLUP
HAVING
SELECT
DISTINCT
ORDER BY
TOP

Answer 1

The order in which a query is executed may not match its text.
But it coincides with the plan by 100% - well, simply because it is carried out according to this plan.