MySQL 5.7

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

CREATE TABLE tablename (
  `ID` INTEGER,
  `Timestamp` INTEGER
);

INSERT INTO tablename
  (`ID`, `Timestamp`)
VALUES
  ('4', '1597228600'),
  ('8', '1597228700'),
  ('12', '1597228700'),
  ('11', '1597228800'),
  ('14', '1597228800'),
  ('9', '1597228900'),
  ('10', '1597228900'),
  ('1', '1597228900'),
  ('2', '1597229000');
select * from tablename order by timestamp, id


ID
Timestamp


4
1597228600

8
1597228700

12
1597228700

11
1597228800

14
1597228800

1
1597228900

9
1597228900

10
1597228900

2
1597229000


select t.* 
from tablename t 
cross join (select * from tablename where id = 11) i
where t.id in (
  (
    select id from tablename 
    where (id < i.id and timestamp = i.timestamp) or timestamp < i.timestamp
    order by timestamp desc, id desc limit 1
  ),  
  (
    select id from tablename 
    where (id > i.id and timestamp = i.timestamp) or timestamp > i.timestamp
    order by timestamp, id limit 1
  ) 
)


ID
Timestamp


12
1597228700

14
1597228800


select t.* 
from tablename t 
cross join (select * from tablename where id = 14) i
where t.id in (
  (
    select id from tablename 
    where (id < i.id and timestamp = i.timestamp) or timestamp < i.timestamp
    order by timestamp desc, id desc limit 1
  ),  
  (
    select id from tablename 
    where (id > i.id and timestamp = i.timestamp) or timestamp > i.timestamp
    order by timestamp, id limit 1
  ) 
)


ID
Timestamp


11
1597228800

1
1597228900

ID	Timestamp
4	1597228600
8	1597228700
12	1597228700
11	1597228800
14	1597228800
1	1597228900
9	1597228900
10	1597228900
2	1597229000