This topic came up some time ago with Graphcool. Most agreed that sequential numbering would be a useful feature, but I don't think it ever got moving.
I don't think a postgres procedure for incrementing would cause any issues, but I'm curious to hear other thoughts.