-- http://www.sharepointlovers.com/reset-list-item-id-in-sharepoint-using-sql/
use WSS_Content_BHB_sites_BedTracker;

-- check current values
SELECT * FROM WSS_Content_BHB_sites_BedTracker.[dbo].[AllListsAux] where ListID='7569e012-d0c3-41f3-813f-a45c4061c1f9'

-- set id next val
update WSS_Content_BHB_sites_BedTracker.[dbo].[AllListsAux] 
set NextAvailableId = 1
where ListID='7569e012-d0c3-41f3-813f-a45c4061c1f9';