UPDATE table1 SET sort_order = 1 WHERE state = "Virginia"

##</code><code>##

ORDER BY sort_order DESC, city DESC