order by not work in distinct sql query

schedule_no
SC-10
SC-5
SC-6
SC-7
SC-8
SC-9

SELECT distinct[schedule_no] FROM [schedule_manager]   order by schedule_no
in above query order by not work
...