How to order in some query editor, like airflow adhoc query, etc without optimizer.skip-redundant-sort prop?

[woowahan-jaehoon]

Hi there.
I have a question.

I found this page that skip ordering if that in subqueries and in future, optimizer.skip-redundant-sort can be removed.
https://trino.io/blog/2019/06/03/redundant-order-by.html

Then, How can I use ordering in some query editor like airflow adhoc query, etc?
Some editors use subquery because to limit result size like this

SELECT *
FROM (
    -- original query
) t
LIMIT 10000

If skip ordering inf subqueries, and when user using order by in that query editor, order by can be ignored.

Then, how can I order result in this case alternate order by?