Id   Location   Area
1   India       Marketing
2   India       Sales
3   India       InformationTechnology
4   India       Sales
5   India       InformationTechnology

Records of InformationTechnology

 3   India       InformationTechnology
 5   India       InformationTechnology

------------------A horizontal line--------------------

Records of Marketing

1   India       Marketing

------------------A horizontal line--------------------

Records of Sales
 2   India       Sales
 4   India       Sales

IF Area ='InformationTechnology',1
IF Area = 'Marketing', 2
IF Area = 'Sales', 3

SELECT Id, Location__c, Area__c, FormulaField__c
FROM CustomObject__c
ORDER BY FormulaField__c