Try this:
DECLARE @id INT
SET @id = 1
SELECT ROW_NUMBER() OVER(ORDER BY T.RowID) AS ID, CLM_NAME, [VALUE]
FROM (
SELECT test_id AS RowID, 'test_id' AS CLM_NAME, CONVERT(NVARCHAR(10), test_id) AS [VALUE]
FROM tbl_test
UNION ALL
SELECT test_id AS RowID, 'name' AS CLM_NAME, [name] AS [VALUE]
FROM tbl_test
UNION ALL
SELECT test_id AS RowID, 'address' AS CLM_NAME, address AS [VALUE]
FROM tbl_test
UNION ALL
SELECT test_id AS RowID, 'mobile' AS CLM_NAME, CONVERT(NVARCHAR(30), mobile) AS [VALUE]
FROM tbl_test
) AS T
WHERE T.RowID = @id