ID | TYPE
-----------
1  | A
2  | A
3  | B
4  | C
5  | C
6  | C
7  | C

ID | TYPE | LOT
1  | A    | 1
3  | B    | 1
4  | C    | 1
 
2  | A    | 2
5  | C    | 2
 
 
5  | C    | 3
6  | C    | 4
7  | C    | 5

SELECT id, type, RANK() OVER(PARTITION BY type ORDER BY id) lot
FROM table
ORDER BY 3,1

ID | TYPE | LOT  
---------------
1  | A    | 1  
3  | B    | 1  
 
2  | A    | 2  
4  | C    | 2  
 
5  | C    | 3  
 
6  | C    | 4  
 
7  | C    | 5

SELECT id, type, lot
FROM (
  SELECT id, type, lot, RANK() OVER(PARTITION BY lot ORDER BY type) AS nbInLot
  FROM (
    SELECT id, type, RANK() OVER(PARTITION BY type ORDER BY id) AS lot
    FROM table
    ORDER BY 3,1
  )
)
WHERE nbInLot <= 2