I think it's the "DESC" that does it, not the "-". Didn't your original posting say you wanted the rows in ASC order? In that case, you definitely need the...
I have to react to your opinion. I can go along with the part about every table having a UNIQUE index, however, I consider it bad practice to use IDENTITY...