New posts in Derived Tables

Is it REALLY possible that the order will not be guaranteed for this particular redundant derived table?

Difference between inline view and WITH clause?