Change/Move Row Position In Sql Compact Edition

Hello,

I have a table with the column description. Lets imagine that I have the records:

"a"
"b"
"c"

If this was a List and I wanted to move the "c" to the first position, I would simply remove the "c" and insert it in the 0 index position.

How can I do this with sql ce?

I could create another column named position and every time I would want to change the position, I would increment every other positions below. Example, "c" goes to first position:

position - description
1 - "a"
2 - "b"
3 - "c"

->

1+1 - "a"
2+1 - "b"
1- "c"

->
1- "c"
2 - "a"
3- "b"

But if I have lets say 100 thousand rows and I want to move the last one to the first position I have to do the operation 100K times.

Is there a more effective way to do what I want?

Thank you,
ARtur