Auto-generated IDs VS Manually created: which approach to chose?

Creating incremented auto-generated integer IDs on a database level was a default approach for a long...