I was perusing the mysql documentation and:
ALTER TABLE tbl_name AUTO_INCREMENT = value
might be what you want, e.g.
ALTER TABLE npc_types AUTO_INCREMENT=49;
I've not tried it, and I would backup your db first if you do plan on trying it, just to be on the safe side
