What you need is to name the subquery:
SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY Name asc) as MyRowNumber, *
FROM tblContactList
WHERE friendOfAutoId=@UserAutoId) AS MyDerivedTable
WHERE MyDerivedTable.MyRowNumber BETWEEN ( ((@pageNo - 1) * @pageSize )+ 1) AND @pageNo*@pageSize