>=> explain select id from mytable order by seed desc limit 1;
Oops, a cut & paste mistake. That should be:
explain select id from mytable order by id desc limit 1;