LIMIT with no ORDER BY

• A

  Whichever ten the plan produces first, which may differ between runs

• B

  The first ten by insertion order

• C

  The first ten by primary key

• D

  Ten rows chosen entirely at random, each one with an equal probability