when writing, order is not guaranteed due to the nature of distributed processing.
If you want the order to be guaranteed, you should order it when reading the data.

Your query does not write any data, DLT does, that is the difference.