increment/rank

Hello,

I am looking for a way to create an increment value for an image
database....
using an SQL database...let's say of some bodies of water:

table water
----------------------------------------------------------------------------
-
image title | URL | keywords | rank
----------------------------------------------------------------------------
-
Peaceful Stream | image/stream.jpg | water peace | 102
Wide Stream | image/wide.jpg | water peace flowing | 101
Rushing River | image/river.jpg | water rushing river | 100
Deep Ocean | image/ocean.jpg | water tide ocean | 99
Dashing Waterfall | image/falls.jpg | water fall cliff | 98

select * from water where keywords like '%water%' and keywords like
'%peace%' order by rank;

I get a two-record list of:
----------------------------------------------------------------------------
-
Peaceful Stream | image/stream.jpg | water peace | 102
Wide Stream | image/wide.jpg | water peace flowing | 101
----------------------------------------------------------------------------
-
...and I select "Wide Stream", I want to change the rank number from 101 to
102.

etc etc etc.

any ideas? I have searched far and wide in the documentation and I am
not seeing the answer aside from just duplicating the entire row
and incrementing the rank number, and then deleting the old record...but
that seems like a pathetic solution.

Thanks
Dan Harrington