SELECT 
case name
When 'R4' then 1
When 'R5' then 2
When 'R6' then 3
When 'R7' then 4
When 'R8' then 5
When 'R9' then 6
When 'R10'then 7
When 'R11'then 8
When 'R1' then 9
When 'R2' then 10
When 'R3' then 11
 END as RID,
 name,groupname FROM TEMP1 T1
ORDER BY  RID

SELECT 
case name
When 'R4' then 1
When 'R5' then 2
When 'R6' then 3
When 'R7' then 4
When 'R11' then 5
When 'R1' then 6
When 'R3'then 7
When 'R2'then 8
When 'R8' then 9	
When 'R9' then 10
When 'R10' then 11
 END as Id,
 name,groupname FROM Tempid
ORDER BY  Id

Hi Ram, what new you are done man?
you have posted same answer as me.

this is not right query beacuse if table contain 1000 
record then you need to give 1000 condition .so it is not 
right answer