title: MySQL Group Per OrderBy
body: <p>I have a data like this. I want to sort this data with a different ProviderId for each row.</p>
  <pre><code>Table1
  ProviderId   Tags
  1            home
  2            phone
  3            notebook
  3            phone
  2            ...
  2            ...
  1            ...
  1            ...
  </code></pre>
  <p>Below I am attaching an example of what I want to do.</p>
  <pre><code>Table1
  ProviderId   Tags
  1            ...
  2            ...
  3            ...
  1            ...
  2            ...
  3            ...
  </code></pre>