declare @currentWeek int =26

select ...

from (...) as t -- selects exactly 52 rows you need

order by case when @currentweek >= t.week then 100+t.week else t.week