First Max value

SELECT Min(ID)
FROM YourTable 
WHERE Value = (SELECT MAX(Value) as value_max FROM YourTable) 

Select allOpen in new window

--use ee
declare @FirsMaxtbl table(ID int, [Value] int);

Insert into @FirsMaxtbl(ID, [Value]) Values
(1, 10), (2, 20), (3, 30), (4, 40), (5, 50), (6, 50), (7, 50);

--Solution:
SELECT  top 1 ID, Value as FirstMaxValue
FROM @FirsMaxtbl Order by Value Desc, ID;

--Result:
ID  FirstMaxValue
5	    50

Select allOpen in new window