Does the 'ORDER BY' clause of a subquery pass through to the main results (POSTGRES)
No, the order by or the sub-query will not influence the order of the outside result. 

If at all, it might be influenced by the order by of the window function. 

But you can never rely on that. 

If you need a specific order for the outer query that you can rely on, you have to use an order by there as well.