db.insert not respecting order of rows

await db.transaction(async (trx) => {
    await trx.delete(sessionTypes).execute();
    console.log('after del', await trx.select().from(sessionTypes).execute());
    for (const session of sTypes) {
        console.log('ins', session);
        await trx.insert(sessionTypes).values(session).execute();
    }
    console.log('after ins', await trx.select().from(sessionTypes).execute());
});

after del []

------

ins {
  id: 'YnfPzN2kyorNZ27LlAtec',
  name: 'Test2',
  category: 'Test',
  length: 30,
  rating: 3
}
ins {
  id: 'nx-eVe-eV5_5EgH_mxY_K',
  name: 'Test3',
  category: 'Test',
  length: 30,
  rating: 2
}
ins {
  id: 'reilg3cziuG7ZoDFHVV6Y',
  name: 'Test3',
  category: 'Test2',
  length: 30,
  rating: 3
}

------

// index 3 is put to the back and everything is shifted foward one

after ins [
  {
    id: 'nx-eVe-eV5_5EgH_mxY_K',
    name: 'Test3',
    category: 'Test',
    length: 30,
    rating: 2
  },
  {
    id: 'reilg3cziuG7ZoDFHVV6Y',
    name: 'Test3',
    category: 'Test2',
    length: 30,
    rating: 3
  },
  {
    id: 'YnfPzN2kyorNZ27LlAtec',
    name: 'Test2',
    category: 'Test',
    length: 30,
    rating: 3
  }
]