try this one

DECLARE @testtable TABLE (id INT, value INT, NAME CHAR(4));

INSERT INTO @testtable

VALUES

(1, 10, 'test'),

(2, 5, 'prod'),

(3, 10, 'test'),

(4, 4, 'test'),

(5, 4, 'test'),

(6, 4, 'test'),

(7, 10, 'test')

delete from @testtable where id in (

select t1.id

from

@testtable t

inner join @testtable t1 on t.id+1=t1.id and t.value=t1.value

)

select * from @testtable