Please, I have faced the below Issue 
In QuickBooks Desktop, when you run a transaction detail report (Transaction Detail By Account), you can see the transaction number that is automatically assigned by QuickBooks. but when exporting to Excel and sorting by Tans Num # I found the number had jumped from 182125 to 182141 on the same day.