DECLARE @MyTable TABLE ( FirstCol VARCHAR(50), SecondCol INT)

INSERT INTO @MyTable (FirstCol, SecondCol)
VALUES ('Waverider',1);
INSERT INTO @MyTable (FirstCol, SecondCol)
VALUES ('Psalms',2);
INSERT INTO @MyTable (FirstCol, SecondCol)
VALUES ('WRV',3);
INSERT INTO @MyTable (FirstCol, SecondCol)
VALUES ('18th Street',3);
INSERT INTO @MyTable (FirstCol, SecondCol)
VALUES ('Soundside',3);


Select 
	FirstCol, 
	SecondCol, 
	ROW_NUMBER() OVER ( PARTITION BY SecondCol ORDER BY FirstCol) * 100 AS Incrementor
From 
	@MyTable
ORDER BY
	SecondCol, FirstCol