MemSQL doesn’t support a way to reset the auto_increment values. Why don’t you want to drop the table and recreate it, given that you are deleting all the data anyway?
This post talks about how to create your own sequence generator using an auto_increment on a reference table, but of course it is not fully general. It might work for some apps.