how to create post_id for a new post in social website

I want to create id for the new post, such as 00001,00002, however, at the same time I need to retrieve the post_id to name the picture url xxx/00001_1.jpg. So should I implement it with mysql(auto_increment) or php/java api?