Order by starting from "the middle" in a windowing function
I wouldn't worry about hardcoding the number of months in a year
create table #t (mm int)

insert #t (mm) values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12)

select mm, (mm + 8) % 12 from #t order by 2 asc