Stored Procedure not sorting correctly

Just recently, I was advised to upgrade from MySQL to MariaDB for a much faster experience and ended up downloading Version 11.1.1.

I am writing some stored procedures that I can pass in parameters and perform a customised query. I have discovered a bug when it comes to the ORDER BY in the stored procedure which is not working correctly, but when I created the same sql select outside of a stored procedure, the ORDER BY is working correctly.

Attached is the stored procedure and the manual select alongside two jpegs to show the difference (from row 5 onwards) where the order should be in the order of the "Dayset", followed by "Depart", "Arrive" and "StartDate", but the StartDate is not sorting correctly.