select min(id) as x_id, store_id
  from (
         select t0.*, t0.id - count(1) as grp_id
           from t t0
           join t t1
             on t0.store_id = t1.store_id
            and t0.id >= t1.id
          group by t0.id, t0.store_id
       )
 group by store_id, grp_id
 order by min(id)

select min(id) as x_id, store_id
  from (
         select t0.*, count(distinct t1.id) - count(distinct t2.id) as grp_id
           from t t0
           join t t1
             on t0.store_id = t1.store_id
            and t0.id >= t1.id
           join t t2
             on t0.id >= t2.id
          group by t0.id, t0.store_id
       )
 group by store_id, grp_id
 order by min(id)

select min(id) as x_id, store_id
  from (
         select t0.*,count(1) - max(t1.cnt) as grp_id
           from t t0
           join (
                  select t0.id, t0.store_id, count(1) as cnt
                    from t t0
                    join t t1
                      on t0.id >= t1.id
                   group by t0.id, t0.store_id 
                ) t1
             on t0.store_id = t1.store_id
            and t0.id >= t1.id
          group by t0.id, t0.store_id
       )
 group by store_id, grp_id
 order by min(id)