SQL Server 2012

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t1(id INT, info INT);

INSERT INTO t1
SELECT 100    ,     1.0             
UNION ALL SELECT 101    ,     2.0                      
UNION ALL SELECT 102    ,     6.0             
UNION ALL SELECT 103    ,     9.0         
UNION ALL SELECT 104    ,     15.0         
UNION ALL SELECT 105    ,     8.0       
UNION ALL SELECT 106    ,     6.0
UNION ALL SELECT 107    ,     8.0       
UNION ALL SELECT 108    ,     6.0
UNION ALL SELECT 109    ,     8.0       
UNION ALL SELECT 110    ,     6.0;
11 rows affected

SELECT 104 AS id
INTO t2
UNION ALL SELECT 110;
2 rows affected

WITH cte AS (
  SELECT t1.*, -sub.c+ SUM(sub.c)  OVER(ORDER BY t1.id) AS grp
  FROM t1
  LEFT JOIN t2
    ON t1.id = t2.id
  CROSS APPLY (SELECT CASE WHEN t2.id IS NULL THEN 0 ELSE 1 END) sub(c)
), cte2 AS (
  SELECT *, ROW_NUMBER() OVER(PARTITION BY grp ORDER BY id DESC) rn
  FROM cte
)
SELECT id, info
FROM cte2
WHERE rn BETWEEN 2 AND 4
ORDER BY id


id
info


101
2

102
6

103
9

107
8

108
6

109
8