mysql insert record before last

mysql insert record before last

I have a small problem I have a database with the following records
tag
---
a
b
c
eof
eof must always be the last record
how can I insert a field before EOF to avoid this situation?
if i delete eof and insert a field and after insert eof, i found this
strange situation, mysql writes eof before ??
tag
---
a
b
c
eof
d
I tried it with order by but does not work I read the record positionally
thanks in advance