Recreate Table With Sorted Data

[John Kebbel]

I have a table with 1600 student locks in random order. I would like them permanently
sorted by the locker number they are assigned to. I assumed that ...

~  I would copy the table under a different name
~ Delete all records from this copy
~ Write a statement that would copy the records from the original table into the copied
table in SORTED order
~ Delete the original table
~ Rename the copy  to the same name as the original

Question 1: Is there a better way to get the desired result?
Question 2: If not, what would the Insert/Select statement look like that would copy the
records over in sorted order?