MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table gpsdata(
  id int
, gpslat numeric (9,6)
, gpslon numeric (9,6)
);
insert into gpsdata values
(69 , 3.214502 , 101.638419),
(70 , 3.214478 , 101.638101),
(71 , 3.214668 , 101.638049),
(72 , 3.215089 , 101.638022),
(73 , 3.215196 , 101.638626),
(74 , 3.215255 , 101.639087),
(75 , 3.215011 , 101.639448),
(76 , 3.215041 , 101.640151);
create view prev
as
select 
  id 
, gpslat
, gpslon
from gpsdata ;
create view distances
as
select
  prev.id prev_
, curr.id curr_
, prev.gpslat p_lat_
, curr.gpslat c_lat_
, prev.gpslon p_lon_
, curr.gpslon c_lon_
, ROUND( 6353 * 2 * 
    ASIN(SQRT( POWER(SIN((curr.GPSLat - abs(prev.GPSLat)) * pi()/180 / 2),2) 
  + COS(curr.GPSLat * pi()/180 ) * COS( abs(prev.GPSLat) *  pi()/180) 
  * POWER(SIN((curr.GPSLon - prev.GPSLon) * pi()/180 / 2), 2) ))
  , 2) as distance_km
from prev join gpsdata curr 
    on prev.id = curr.id - 1
where curr.id >= 1
;
select 
  a.prev_ from_
, a.curr_ to_
, a.distance_km distance_between
, sum(b.distance_km) cumulative_km
from 
  distances a
, distances b
where a.prev_ >= b.prev_
group by a.prev_, a.curr_, a.distance_km
order by a.prev_;


from_
to_
distance_between
cumulative_km


69
70
0.04
0.04

70
71
0.02
0.06

71
72
0.05
0.11

72
73
0.07
0.18

73
74
0.05
0.22999999999999998

74
75
0.05
0.27999999999999997

75
76
0.08
0.36


select 
  min(prev_) from_
, max(curr_) to_
, sum(distance_km) total_km
from 
  distances
;


from_
to_
total_km


69
76
0.36

from_	to_	distance_between	cumulative_km
69	70	0.04	0.04
70	71	0.02	0.06
71	72	0.05	0.11
72	73	0.07	0.18
73	74	0.05	0.22999999999999998
74	75	0.05	0.27999999999999997
75	76	0.08	0.36