You wouldn't bet on a little street in Edinburgh - or its eccentric inhabitants - surviving a series of world-battering catastrophes, but that's both the starting and the ending point of Nick Holdstock's fascinating first novel