Either change the alias so it is different from column name and then use it (with TO_DATE()) in order by clause or change order by clause to
ORDER BY TO_DATE(Substr(INCREMENTDATE, 1, 10))
If this solves your problem please accept the solution to make it easier for others to find it. Thank you.