How to resequence an seer list id

I have an Oracle list like this:fruit id-------- -----apple 1plum
9pear 55orange 104..The id buttress numbers are wrong. How can
we transform a id of any quarrel to be re-sequenced like this: fruit
id-------- -----apple 1plum 2pear 3orange 4What's a many
fit proceed to do this?