Ok, so I guess you need something like this:

INSERT INTO Table2 (Number, Name, Address)

SELECT ROW_NUMBER() OVER(ORDER BY Name, Address) + (SELECT MAX(Number) FROM Table2) AS counter,

Name, Address

FROM Table1