ORDER BY clause ignored in subquery

We are migrating many MySQL instances to MariaDB 10.2.8. We have a very large library of legacy code that comes with the migration. An issue we are trying to resolve is that a subquery containing an ORDER BY does not sort the output. Here is an example query and the results, and yea I am aware that a subquery is not required in this case, but this query is for example purposes only:

Query:

SELECT * FROM (
   SELECT ta.status,tb.delete_request_id,tb.id AS aux_id
   FROM Table_A AS ta INNER JOIN Table_B AS tb ON tb.id = ta.id
   WHERE tb.delete_request_id = 36 ORDER BY tb.id DESC
) AS t;

results on MySQL:

results in MariaDB:

Is this a bug in MariaDB? Is there a SQL_MODE or other environment variable that will fix this without re-coding (not that I have found). The only solution i have found is to write the output to a temporary table and select from there. This would require a large coding effort on our part. Please help!