Using below code we can show auto increment column number in SharePoint list.First download the Sputility.js file and jquery files after that create a SNO column with
var clientContext = new SP.ClientContext(siteUrl);
// Get the liste instance
var oList = clientContext.get_web().get_lists().getByTitle('Test List');
var camlQuery = new SP.CamlQuery();
// Get only the last element
camlQuery.set_viewXml('<Query><OrderBy><FieldRef Name=\'ID\' Ascending=\'False\' /></OrderBy></Query><RowLimit>1</RowLimit></View>');
this.collListItem = oList.getItems(camlQuery);
Solution: If you are planning to perform an in-place upgrade to SharePoint 2010, please upgrade the server machines in your farm to a 64 bit edition of Windows Server 2008 SP2 or higher, or migrate the current content databases from this farm to a new farm with servers running 64 bit edition of Windows Server 2008 SP2 or higher. Before attempting to install or upgrade to SharePoint 2010, please ensure that you run the SharePoint 2010 pre-requisites installer beforehand to ensure you have the correct set of prerequisites and patches installed.