MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `example_table` (
  `id` int(11) NOT NULL,
  `imei` bigint(20) NOT NULL,
  `run_date_time` datetime NOT NULL,
  `in_here` tinyint(1) NOT NULL DEFAULT '-1',
  `add_meter` int(11) NOT NULL DEFAULT '0'
);
insert into example_table
 (id, imei, run_date_time, in_here, add_meter) values 
 (1,12,'2019-01-20 04:04:12',0,150)
,(2,12,'2019-01-20 04:04:12',1,250)
,(3,12,'2019-01-20 04:04:12',1,260)
,(4,12,'2019-01-20 04:04:12',0,270)
,(5,12,'2019-01-20 04:04:12',0,280)
,(6,12,'2019-01-20 04:04:12',1,290)
,(7,12,'2019-01-20 04:04:12',1,295)
,(8,12,'2019-01-20 04:04:12',1,300)
,(9,12,'2019-01-20 04:04:12',1,302)
,(10,12,'2019-01-20 04:04:12',1,303)
,(11,12,'2019-01-20 04:04:12',1,304)
,(12,12,'2019-01-20 04:04:12',0,305)
,(13,12,'2019-01-20 04:04:12',0,320)
,(14,12,'2019-01-20 04:04:12',1,324)
,(15,12,'2019-01-20 04:04:12',1,325)
,(16,12,'2019-01-20 04:04:12',1,330)
,(17,12,'2019-01-20 04:04:12',1,331)
,(18,12,'2019-01-20 04:04:12',1,332)
,(19,12,'2019-01-20 04:04:12',0,333)
,(20,12,'2019-01-20 04:04:12',0,336)
select
 imei, 
 min(run_date_time) as start_dt,
 max(run_date_time) as stop_dt, 
 max(add_meter) - min(add_meter) as diff
from
( 
  select imei, id, run_date_time, add_meter, in_here, 
  case
  when @prev_imei = imei and @prev_ih = in_here then @rnk
  when @rnk := @rnk + 1 then @rnk
  end as rnk,
  @prev_imei := imei as prev_imei,
  @prev_ih := in_here as prev_ih
  from example_table t
  cross join (select @rnk := 0, @prev_ih := null, @prev_imei := null) vars
  order by imei, id, run_date_time
) q
where in_here = 1 
group by imei, rnk 
having (max(id)-min(id)) > 3 
order by imei, min(id);


imei
start_dt
stop_dt
diff


12
2019-01-20 04:04:12
2019-01-20 04:04:12
82