Fetch Records alternatively from database
Without considering performance, it is possible to solve by using one query with 3 subquery inside.

SELECT * FROM 
   (SELECT * FROM 
       (SELECT id, Date_Time, MOD(@no := @no + 1, 2) AS even 
        FROM recorddata  ORDER BY Date_Time ASC) l
    WHERE even = 0) a, 
   (SELECT id, Date_Time FROM recorddata ORDER BY Date_Time ASC) b
WHERE a.Date_Time &lt; b.Date_Time
GROUP BY a.id