title: Increment value upto missing consicutive numbers
body: <p>I have a table with a field have values 1,2,3,5,6,....
  My problem is,When i try to insert "2" current 2,3 are incremented with 1 and 5,6 remains unchanged(because 4 is not exist),Then in the place of 2 new value needs to be inserted.
  I try update query with </p>
  
  <pre><code>    Update table set v1=v1+1 where v1&gt;=newvalue
  </code></pre>
  
  <p>before insert a new value.But 5,6 also incremented with 1.I dont know how to do this.Does anyone know how to handle this ,Please help me.I have large amount of data,so not possible to make loop for update each value</p>