SELECT id, TYPE FROM (
   SELECT id, TYPE, 
   IF(@myvar = 0 OR @myvar = TYPE, @counter := @counter + 1, @counter := 1) sequence,  
   @myvar := TYPE FROM mytable 
   JOIN (SELECT @myvar := 0, @counter := 0 ) a
   ORDER BY TYPE DESC, id) b 
ORDER BY sequence, TYPE DESC,  id

此查询适用于任何级别.

This query will work for any level.

如有必要，请放置外部查询以仅获取相关字段.

Put an outer query if necessary to fetch only relevant fields.

检查这个 SqlFiddle