In the visionary work of late artist John Scott, ‘the future is coming at us with knives’