title: Can a sequence guarantee the given order?
body: <p>Using this Oracle sequence definition:</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE SEQUENCE MY_SPECIAL_COUNTER
    START WITH 100
    INCREMENT BY -1
    MAXVALUE 100
    MINVALUE 0
    NOCYCLE
    NOCACHE
    ORDER
    ;
  </code></pre>
  
  <p>Is it guaranteed, that this sequence will ALWAYS return</p>
  
  <ul>
  <li>each number once from 100 to 0 </li>
  <li>in the given order from 100 to 0 and </li>
  <li>no single number will be obmitted and </li>
  <li>independent of multiple concurrent session in the very moment of the request </li>
  </ul>
  
  <p>the correct number?</p>