MySQL

For this challenge we are using MySQL.


          # TABLE SETUP
          CREATE TABLE Logs (
            log_id INT AUTO_INCREMENT PRIMARY KEY
          );
          INSERT INTO Logs (log_id)
          VALUES
            (1),
            (2),
            (3),
            (7),
            (8),
            (10);

          # QUERY
          SELECT start.log_id AS start_id, (
              SELECT min(s.log_id) AS id
              FROM Logs AS s
                LEFT OUTER JOIN Logs AS e ON s.log_id = e.log_id - 1
              WHERE e.log_id IS NULL
                AND s.log_id >= start.log_id
            ) AS end_id
          FROM Logs AS start
            LEFT OUTER JOIN Logs AS end ON end.log_id = start.log_id - 1
          WHERE end.log_id IS null;