title: Update query to update values incrementally and then loop PostgreSQL
body: <p>I am trying to write a query which will update the following below:</p>
  <ol>
  <li>id = 1 --&gt; id_scraping_account = 1</li>
  <li>id = 2 --&gt; id_scraping_account = 2</li>
  <li>id = 3 --&gt; id_scraping_account = 3</li>
  <li>id = 4 --&gt; id_scraping_account = 1</li>
  <li>id = 5 --&gt; id_scraping_account = 2</li>
  <li>id = 6 --&gt; id_scraping_account = 3</li>
  </ol>
  <p>The main thing I am trying to understand is the structure of the query</p>