When a course is restored from a backup, the sortorder field is set to 0.

It will remain at this value until something else triggers a call to fix_course_sortorder() (e.g. a course somewhere on the site is created / deleted or has is manually re-ordered).

The effects of this are not usually immediately obvious, but it would be good to get it fixed for consistency.