Doesn't that make sense if data is clustered by the primary key, as InnoDB does?
MySQL does have an implicit ordering on GROUP BY queries, but it is deprecated and should not be relied on.
My favourite ever SQL Server hack was one done by a guy called Jeff Moden, who came up with a running total update that relied on a specific quirk of SQL Server clustered indexes. The amount of effort he put into it is quite remarkable! [1]
1. (Create a temp account to check it out, they're not spammers) http://www.sqlservercentral.com/articles/T-SQL/68467/