they are sort (by default), which tuple seems first in the table.
But not the values of any field.
i mean, in your table, you have
id name
2 "A"
1 "C"
3 "B"
like that then the sort also in the tuple wise, but not on the attribute (either id or name) wise.