Zerofill Auto Increment - mySql
I have only seen one instance where this made a difference.  The int was being cast as a string, and then sorted alphabetically.  The zero fill prevented a strange sort order, such as 10 coming before 9.