-
The values aren’t stored out of order. As the ID column is acting as a foreign key, the corresponding v values to each ID from the kt table are as follows:
ID v 1002 200 1001 100 1003 300 1001 100
That’s why they appear in the order they do in the select query. Hopefully that’s clear enough.