I said low, not zero.
I wasn't surprised that it happened; I was surprised that it happened more often than expected, based on it sounding like selling tickets for a school event, which in my experience translates to like five hundred distinct purchasers (new registrations) spread over a couple of weeks.
I think we're already agreed about LAST_INSERT_ID being the probable fix. And even possibly without the knife-edge timing ("IMMEDIATELY"), if this is correct: