Why does the position of rows in a table column change when data is updated?

Question

PostgreSQL

Good afternoon) Can you please tell me why when changing the data in the table, the changed line is overwritten at the end of the table and how this can be avoided, maybe I made the request incorrectly?

await db.query(`UPDATE resume set value = $1, type = $2 where id = $3  RETURNING *`, [value, type, id ])

If I now change the column with index 112, then it will stand at the end of the table, how can this be avoided, and so that changes just occur in the row, without overwriting it at the end

Answer 1

in the sql standard there is no beginning and end, each subd does everything in its own way, the order is guaranteed only by explicitly specifying it, through order by