Material document with higher number created with earlier creation date

Hi all, This query was raised with SAP Support earlier today - I have added the answer here in the community in case anyone in our community has a similar query.

Question: If a material document was created yesterday with number 5000001002 how can a document that was created the following day have number 5000001001 (a lower number) ?