here you go broski!

CREATE Table #TEMP

(

id varchar(100),

MID VARCHAR(100)

)

INSERT INTO #TEMP

VALUES ('100',NULL),

('200',NULL),

('300',NULL),

('400',NULL),

('500',NULL)

UPDATE OP

SET MID = OL.id

FROM (SELECT LL.ROW_ID, LL.ID,LL.MID

FROM(

SELECT ROW_ID =ROW_NUMBER() OVER (order by ID),ID,MID

FROM #TEMP I)LL)OP

JOIN (

SELECT ROW_ID =ROW_NUMBER() OVER (order by ID),ID,MID

FROM #TEMP I)OL ON OL.ROW_ID = OP.ROW_ID -1

SELECT * FROM #TEMP